Selecting tables and/or views for replication
This procedure describes how to select the source tables or views that you want to replicate. Note that tables can be selected from any supported endpoint, but views can only be selected from the following endpoints:
- Teradata
- Amazon Redshift
- PostgreSQL
- MySQL
- SAP Sybase ASE
- IBM DB2 for LUW
- IBM DB2 for z/OS
- Oracle
- Microsoft SQL Server
- ODBC with CDC
- ODBC
-
Replication of views is supported in Full Load Only tasks only, except when replicating from the following sources:
- Amazon Redshift
- Teradata
- ODBC with CDC
-
Views are replicated to the target endpoint as tables
-
When replicating views, the corresponding tables are created without a primary key. This presents an issue for Apply Changes tasks, which require the target tables to have a primary key. Therefore, if you are also running Apply Changes tasks (using one of the CDC-capable endpoints mentioned above), you need to define one or more primary keys for each of the target tables using a transformation. For an explanation of how to accomplish this, see Using the Transform tab in Defining transformations for a single table/view.
When working with ODBC with CDC and Teradata source endpoints, any views and tables that you want to replicate must have the same context field(s). If you only want to replicate views, then all of the views must have the same context field(s).
For information on setting up context fields, see "Configuring Change Processing Settings" in the Qlik Replicate Setup and User Guide.
Once you have selected tables/views to replicate, you can run the replication task. However, if you need to make any changes to the structure of the tables in the target endpoint or only select specific columns, you will need to carry out one or both of the following procedures:
To select tables/views:
-
Open the task you are working with if it is not already displayed in a dedicated tab.
For information on opening a task, see Editing a replication task.
-
In Designer mode, on the right side, click Table Selection.
If the source endpoint does not support view selection, the Select Tables dialog box opens. If the source endpoint supports view selection, the Select Tables/Views dialog box opens.
See the following for information on how to work with the Select Tables/Select Tables/Views dialog box: